const router = require('koa-router')()
const db=require('../config/db')

router.get('/', async (ctx, next) => {
  var sqlSelect='select * from chapters'
  var result=await db.query(sqlSelect,[])
  var chapterList=result
  await ctx.render('index', {
    chapterList:chapterList
  })
})

router.get("/detail/:id",async (ctx,next)=>{
  var chapterId=ctx.params.id
  console.log(chapterId)
  var selectSql='select * from chaptersDetail where chapterId=?'
  var result=await db.query(selectSql,[chapterId])
  console.log(result[0])
  await ctx.render('detail',{
    chapter:result[0]
  })
})
router.get('/string', async (ctx, next) => {
  ctx.body = 'koa2 string'
})

router.get('/json', async (ctx, next) => {
  ctx.body = {
    title: 'koa2 json'
  }
})

module.exports = router
